<?
	include "include/config.inc";
	$page["title"] = "Latest values";
	$page["file"] = "latest.html";
	show_header($page["title"],0,0);
?>

<?
	show_table_header_begin();
	echo "LATEST DATA";

	show_table_v_delimiter();

	echo "<font size=2>";

	$result=DBselect("select h.hostid,h.host from hosts h,items i where h.status=0 and h.hostid=i.hostid group by h.hostid,h.host order by h.host");

	for($i=0;$i<DBnum_rows($result);$i++)
	{
		$hostid_=DBget_field($result,$i,0);
		$host=DBget_field($result,$i,1);
		if( isset($hostid) && ($hostid == $hostid_) )
		{
			echo "<b>[";
		}
		echo "<a href='latest.html?hostid=$hostid_'>$host</a>";
		if(isset($hostid) && ($hostid == $hostid_) )
		{
			echo "]</b>";
		}
		echo " ";
	}

	echo "</font>";
	show_table_header_end();
	echo "<br>";

	if(isset($hostid))
	{
		$result=DBselect("select host from hosts where hostid=$hostid");
		$host=DBget_field($result,0,0);

		show_table_header("<a href=\"latest.html?hostid=$hostid\">$host</a>");
#		show_table_header_begin();
#		echo "<a href=\"latest.html?hostid=$hostid\">$host</a>";
#		show_table3_v_delimiter();

		echo "<TABLE BORDER=0 COLS=4 WIDTH=\"100%\" cellspacing=1 cellpadding=3>";
		cr();
		echo "<TR BGCOLOR=\"CCCCCC\">";
		cr();
		echo "<TD><B>Description</B></TD>";
		cr();
		echo "<TD WIDTH=\"10%\" NOSAVE><B>Last check</B></TD>";
		cr();
		echo "<TD WIDTH=\"10%\" NOSAVE><B>Last value</B></TD>"; 
		cr();
		echo "<TD WIDTH=\"5%\" NOSAVE><B>Change</B></TD>"; 
		cr();
		echo "<TD WIDTH=\"10%\" NOSAVE><center><B>History</B></center></TD>";
		cr();
		echo "<TD WIDTH=\"10%\" NOSAVE><center><B>Trends</B></center></TD>";
		cr();
		echo "</TR>";
		cr();


		$col=0;
		$result=DBselect("select h.host,i.itemid,i.description,i.lastvalue,i.prevvalue,i.lastclock,i.status,h.hostid from items i,hosts h where h.hostid=i.hostid and h.status=0 and h.hostid=$hostid order by h.host,i.description");
		for($i=0;$i<DBnum_rows($result);$i++)
		{
			$host=DBget_field($result,$i,0);
			$itemid=DBget_field($result,$i,1);
			$hostid=DBget_field($result,$i,7);


			if($col==1)
			{
				echo "<tr bgcolor=#DDDDDD>";
				$col=0;
			} else
			{
				echo "<tr bgcolor=#EEEEEE>";
				$col=1;
			}
			$prevvalue=DBget_field($result,$i,4);
			$description=DBget_field($result,$i,2);
			$lastvalue=DBget_field($result,$i,3);
			$lastclock=DBget_field($result,$i,5);
			if($lastclock==NULL)
			{
				$lastclock="<center>-</center>";
			}
			else
			{
				$lastclock=date("H:i:s",$lastclock);
			}
			$itemid=DBget_field($result,$i,1);
			$status=DBget_field($result,$i,6);
			$dif=$lastvalue-$prevvalue;
			echo "<td>$description</td>";
			echo "<td>";
			if($status==2)
			{
				echo "<font color=\"#FF6666\">";
			}
			elseif($status!=0)
			{
				echo "<font color=\"#666666\">";
			}
	
			echo "$lastclock</td>\n";
			if($lastvalue!=NULL)
			{
				if(round($lastvalue)==$lastvalue)
				{ 
					echo "<td>"; printf("%.0f",$lastvalue); echo "</td>";
				}
				else
				{ 
					echo "<td>"; printf("%.2f",$lastvalue); echo "</td>";
				}
			}
			else
			{
			echo "<td><center>-</center></td>";
			}
			if( $dif != 0 )
			{
				echo "<td>$dif</td>";
			}
			else
			{
				echo "<td><center>-</center></td>";
			}
			echo "<td><center><a href=\"history.html?action=showhistory&itemid=$itemid\">Show</a></center></td>";
			echo "<td><center><a href=\"trends.html?itemid=$itemid\">Show</a></center></td>";
			echo "</tr>";
		}
		echo "</table>";
		show_table_header_end();
	}
?>

<?
	show_footer();
?>
